I need to show the total in card as well as in table also but i have exclude the Type C in table visual but the total should be 1000 ------------------------------ Kumar cy ------------------------------
Could put the Total on it's own card visual or something? This measure will calculate the overall total regardless of filters on type. Measure = CALCULATE(SUM(Sheet1[Amount]),ALL(Sheet1[Type])) You could then filter the table and turn off ...
Hi Kurt, I'm not exactly sure of the end goal, but you could use Power Query to create date logic. Here are some of the available functions: So, for instance, if you want to dynamically flag the previous 2 quarters you could write a custom column ...
Hi Power Users, I need help with a DAX calculation. I have 2 table and have relationship. I have Type column in table 1 and Amount column in Table 2. Below is the example data. Input Type Amount A 100 ...
Thanks Mark and Greg. I could workaround with a drill-through for the same table but 2 visuals. So if I click on a certain column value, it filters the same table, different visual for that lengthy value selected. Two tables may have worked, but the ...
Register for our no-charge webinar series to learn how to protect yourself from being a a target of cyber threats! With over 164.68 million sensitive records exposed in 2019, there has never been a greater need for cyber security training. ...