Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have such tabe
column1, column2,etc,etc,Total
27k, -27k, , , 0
In the table i dont need to show records that total is 0 that is ok i use visual filter Total is greater then 0
But i also need to show column1(which values is a mesure) in a card as overall sum and if i simply sum this measure it includes this 27k where it should not include.
How should i calculate so that my calculations for summarizing column1 values exludes column1 value if the wholeor columns for that row sum is equal to 0
Total is also a measure in my table
Hi @jja
Is Total a Calculated column in your table? If yes, you can filter it
Measure = SUMX(FILTER(yourTable,[Total]<>0),yourTable[Column1])
HI @Vera_33
Column1 and Total is a measure in my visual table and your suggested formula does not filter out desired results. I create a measure for all columns and also create a measure for total. Then i add to my visuals a table and drag measures
Hi @jja
So [column1] and [Total] are measures in a visual table...can you provide your current measure - sum of coumn 1 in a card visual or some sample data? You need to calculate column1 and total first, then filter total = 0 out then sum up column1 in a card, right?
hi @Vera_33
Yes i need to filter total >0 and then sum up column1 in a card
DAX for column1=
Hi @jja
Can't tell from your measure that what you have for Rows...but you can try below way if you have one native column from your table to display in your visual table
test =
VAR T1= ADDCOLUMNS(VALUES(yourTable[yourColumn]),"Column1",[Column1 measure],"Total",[Total measure])
RETURN
SUMX(FILTER(T1,[Total]>0),[Column1])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |