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.
Basically I need to get the total of a table and present it as a card visual.
The idea is that I have been given a power BI with multiple visual tables on it and I want to get ALL the Totals and then add them together. So, as I first step I would like to create a measure that gives me only the total one existing visual table. Any ideas?
Hi @alex_smith ,
If in the Total row of the table visual, the measure can get the correct result 9, then directly put it in a card visual.
If not, modify the formula like this:
Measure =
VAR _T =
ADDCOLUMNS ( 'Table', "measure", "post your original formula here" )
RETURN
SUMX ( _T, [measure] )
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @alex_smith,
From what I understand, you want something like this:
I was able to create this using a simple count measure:
Count of ProductName = COUNT('Product'[ProductName])
Let me know if this solves your problem or if there are any other scenarios involved in your use case.
Hope that helps!
Place the "code" column in the card. Check if there is available "count" option. Its the same as dax countrows
This is not working because, I need to filter the visual with FIlters that are measures. So, maybe the question should be how can I convert a measure to a calculated column? (in order to apply filters in the visual)
Simple sum should be enough, click on mark near "x"
or through dax, to put in card visual
There is not such an option, unfortunatelly. Other info that might help, the table visual has filters that depend on other measures.
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |