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 been working with the next data model and have found a few troubles working with measures to show the total:
mi calendar is this and i manage it with "accounting period"
and finally i have the table with the measures, the first and the second one are a simple sum of rev column (rev table) named "[rev uf]" and collect (collect table) named "[collect uf]"and this two are the only ones that come from this two tables.
then i have all my measures:
- CxC_i = [Rev UF]-[Collect UF]
Solved! Go to Solution.
Hi @Anonymous ,
Measures are based on context so they are always calculated based on the filters, columns, slicers and so on that you have on your visualizations. In this case this type of calculation needs to have an aggregator measure you need to do something similar to this:
DSO TOTAL = IF(HASONEVALUE(Periodos[Accounting Period]), [DSO_Days], SUMX(Periodos,[DSO_Days]))
Then use this measure in the matrix. be aware that the table names and columns may needs changes.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
Measures are based on context so they are always calculated based on the filters, columns, slicers and so on that you have on your visualizations. In this case this type of calculation needs to have an aggregator measure you need to do something similar to this:
DSO TOTAL = IF(HASONEVALUE(Periodos[Accounting Period]), [DSO_Days], SUMX(Periodos,[DSO_Days]))
Then use this measure in the matrix. be aware that the table names and columns may needs changes.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |