Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi i´m new here i learn a lot in this forum,i have a question that i could found anywhere so here is
i have 2 measures A an B both are COUNTS of id and B the same but have a filter so
MeasureA > Measure B
then i have a rowC wich have 3 diferent values (1,2 and 3)
so my question is there is a way that i could make the following next measure?
MeasureNew
if value rowC is 1 then measureA-MeasureB
if value rowC is 2 then measureA
if value rowC is 3 then measureA+MeasureB
is for a visual that have to show nor a matrix.
Solved! Go to Solution.
Hi,
try this
Hi,
try this
try this
Measure = SWITCH(TRUE(), [RowC] = 1, [MeasureA] - [MeasureB], [RowC] = 2, [MeasureA], [RowC] = 3 , [MeasureA] + [MeasureB])
Hi @Anonymous ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
I @v-frfei-msft have a issue about confidenciality so i gonna try to put images to make a better explanation (all is in a same table):
First image a measure that counts id but with a filter of a row called MATRIZ RC wich have 3 values yellow black and gray, the second image show a measure that also is a count with the same filter but with another filter wich is a column "yes or no" so what i need is create a new measure that follows in a visual:
NEWMEASURE:
Yellow1-Yellow2
black1
gray1 + gray2
so in my visual should be for "ENERO" (JANUARY) yellow =500 black= 61 and gray =150
i hope i get myself clear thanks for the attention.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |