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?
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 @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:
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.
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!