Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys!
I am doing a matrix with two versions and I need to calculate the diference between the second and the first.
The values are in the same column and I am using the same measure to calculate the total.
Is it possible to create a dinamic measure to calculate this?
I can change the versions, but always keeping two versions to compare the diference between it.
The choose will be from data segmentation or filter.
Thanks a lot for help!!!
Solved! Go to Solution.
You are using Versao in the column of the matrix. Remove that and do this:
Create this measures:
Total Ton R&O =
calculate( SUM('fPlanoVendas'[Tonelada]), 'fPlanoVendas'[Version] = "2022 Rev.1 - R&O")
Total Ton Verdas =
calculate( SUM('fPlanoVendas'[Tonelada]), 'fPlanoVendas'[Version] = "2022 Rev.2 - Vendas")
Diff = [Total Ton R&O] - [Total Ton Verdas]
Use all 3 measures in the matrix ( and dont forget to remove Versao from the column matrix)
@MatSantos , You need to create a measure like
calculate( SUM('fPlanoVendas'[Tonelada]), filter('fPlanoVendas', 'fPlanoVendas'[Version] = "2022 Rev.1 R&O")) -calculate( SUM('fPlanoVendas'[Tonelada]), filter('fPlanoVendas', 'fPlanoVendas'[Version] = "2021 Rev.1 R&O"))
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi,
The mesure worked in the card, but when I put in the matrix shows other value and duplicate the column.
You are using Versao in the column of the matrix. Remove that and do this:
Create this measures:
Total Ton R&O =
calculate( SUM('fPlanoVendas'[Tonelada]), 'fPlanoVendas'[Version] = "2022 Rev.1 - R&O")
Total Ton Verdas =
calculate( SUM('fPlanoVendas'[Tonelada]), 'fPlanoVendas'[Version] = "2022 Rev.2 - Vendas")
Diff = [Total Ton R&O] - [Total Ton Verdas]
Use all 3 measures in the matrix ( and dont forget to remove Versao from the column matrix)
Thanks a lot!!!!
It is working!
Can you provide the DAX measures for those 2? R&o and Vendas?
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |