Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everybody,
I was looking in the forum about something like LOA in Tableau, that aggregates a measure in diferents levels. But I think I'm missing something in Power BI, because I just wanted to show the sum of Clients in a new measure using "qtd" with the values that are not blank. So that measure will show only a value 39, because its on level of Client. Has someone faced something that solves this question? Thanks in advance
Solved! Go to Solution.
You may refer to the measure below.
Measure = SUMX ( FILTER ( Table1, NOT ( ISBLANK ( Table1[Cliente] ) ) ), Table1[qtd] )
You may refer to the measure below.
Measure = SUMX ( FILTER ( Table1, NOT ( ISBLANK ( Table1[Cliente] ) ) ), Table1[qtd] )
Thank you very much. It really helps me
User | Count |
---|---|
13 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
3 | |
2 | |
2 |