The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
i have the following measure that calulates the value for each row in a table visual.
Solved! Go to Solution.
I found the solution and it was to wrap a new measure in a Sumx(Summarize( which then gave the correct figures in a card.
I found the solution and it was to wrap a new measure in a Sumx(Summarize( which then gave the correct figures in a card.
Hi Neal Please attach the sample data and PBIX , you can remove your confidential data and just give part of it . .so that we can analyze better . . because it depends on what your data is
Hi, unfortunately all of it is confidential as we have a very strict privacy policy.
if you have any ideas that i could try, that would be appreciated.
For a bit of context, i have a table visual and one column is a staff members start date and the messure above calculates whats their score would of been if they where employeed at the start of the year. and it's this column that i need totalled, and put into a card.
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |