In my Power BI dashboard, I have used a Measure to exclude data based on the results returned in the Measure.
Right now, I need to recreate this into a Paginated Report but I realized that I am unable to use the created Measure as a parameter to filter out the data.
May I know what is the best way to use a created Measure in the Power BI dataset to filter out the generated result?
The DAX for the Measure is below:
var tot_tenants = Calculate(Calculate(COUNTROWS(Filter(Brand,[Occupancy Cost % AVG Last 3 Months]>0)),All(Brand),All('Trade Category')))
return if(isblank([Occupancy Cost % AVG Last 3 Months]),Blank(), if([Brand Rank by Avg Occupancy Cost % Last 3 Months] > (tot_tenants * 0.8),1,0))
And the Power BI report is filtering the data in a table visual where the result from the Measure is greater than 0.
As you can see above, the created Measure is also referring to other Measure, as well as the ALL function in the calculation.
Please help, as i am lost!
